﻿CREATE TABLE [dbo].[Interchange]
(
[DataFileKeyID] [int] NULL,
[AuthorizationInformationQualifier] [nvarchar] (2) NULL,
[AuthorizationInformation] [nvarchar] (10) NULL,
[SecurityInformationQualifier] [nvarchar] (2) NULL,
[SecurityInformation] [nvarchar] (10) NULL,
[InterchangeSenderQualifier] [nvarchar] (2) NULL,
[InterchangeSenderID] [nvarchar] (15) NULL,
[InterchangeReceiverQual] [nvarchar] (2) NULL,
[InterchangeReceiverID] [nvarchar] (15) NULL,
[InterchangeDate] [nvarchar] (20) NULL,
[InterchangeTime] [nvarchar] (20) NULL,
[InterchangeControlStandardsIdentifier] [nvarchar] (1) NULL,
[InterchangeControlVersionNumber] [nvarchar] (5) NULL,
[InterchangeControlNumber] [nvarchar] (9) NULL,
[AcknowledgementRequested] [nvarchar] (1) NULL,
[UsageIndicator] [nvarchar] (1) NULL,
[ComponentElementSeparator] [nvarchar] (1) NULL,
[NumberofIncludedFunctionalGroups] [int] NULL,
[EDIMessageType] [nvarchar] (50) NULL,
[OriginalInterchange] [xml] NULL,
[InterchangeIDKey] [int] NOT NULL IDENTITY(1, 1),
[ProcessingDate] [datetime] NULL,
[BTSMessageID] [nvarchar] (100) NULL,
[BTSInterchangeID] [nvarchar] (100) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]


GO
EXEC sp_addextendedproperty N'MS_Description', N'ISA01__AuthorizationInformationQualifier', 'SCHEMA', N'dbo', 'TABLE', N'Interchange', 'COLUMN', N'AuthorizationInformationQualifier'
GO
EXEC sp_addextendedproperty N'MS_Description', N'ISA02__AuthorizationInformation', 'SCHEMA', N'dbo', 'TABLE', N'Interchange', 'COLUMN', N'AuthorizationInformation'

